package com.practice.springboot_01_zwj.mapper;

import com.practice.springboot_01_zwj.entity.AssignedTask;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface AssignedTaskMapper {
    int addAssignedTask(AssignedTask assignedTask);

    int updateAssignedTask(AssignedTask assignedTask);

    int deleteAssignedTask(Integer id);

    List<AssignedTask> selectAssignedTask( @Param("proposeLeader") String proposeLeader,
                                           @Param("finishState") String finishState,
                                           @Param("deptName") String deptName);

    // 新增统计方法
    Integer countByFinishState(@Param("proposeLeader") String proposeLeader,
                               @Param("finishState") String finishState,
                               @Param("deptName") String deptName);

}
